VoidTransaction

Entity Definition

Logical Name : VoidTransaction
Physical Name : TR_VD_PST

A non sales transaction that records the cancellation of another Transaction, either before or after that Transaction was completed.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
ReversalTransactionID (FK) A universally unique identifier (UUID) for the a new Transaction that reverses the Transaction being cancelled. ID_TRN_RVS IdentityUUID char(32) Transaction(TR_TRN)
CancelledTransactionID (FK) A universally unique identifier (UUID) for the Transaction that is being cancelled. ID_TRN_CNL IdentityUUID char(32) Transaction(TR_TRN)
VoidTypeCode A mnemonic code denoting the kind of Transaction Void operation that is being performed. e.g. PostVoid, Void, SuspendDelete CD_TYP_VD Code4 char(4)
VoidAmount The monetary value of the Transaction being cancelled after it was completed. MO_VD MoneyShortRetail decimal(7,2)
VoidQuantity The number of Items in the Transaction being cancelled after it was completed. QU_VD Quantity DECIMAL(9,3)

Relationships

Parent Entity Verb Phrase Child Entity
Transaction was cancelled by VoidTransaction
Transaction was caused by VoidTransaction
ControlTransaction can be a VoidTransaction

Logical Views containing VoidTransaction

Logical View
Logical 02200 - Transaction Macro View
Logical 02400 - Control Transaction Macro View
Logical 02440 - Control Transaction - Voids View